Agent Central Host Computer/Agent - Central Host Computer.iso/_SETUP.1/veventspart2.sql

Text File | 2000-05-12 | 1KB | 29 lines

/*
This is one of the constituent views of vallevents... collecting all events together.
*/
create or replace view veventsPart2 as
select DET_SEQ_NUM, FAREBOX_GLID ,CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
 0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , '   ' setclr, 0 alarm, rpad('(13) Cons Pwr Bgn', 200) event
from conpwrb
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
 0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , '   ' setclr, 0 alarm, '(14) Cons Pwr End' event
from conpwre
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
 0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID ,'   ' setclr, 0 alarm, '(15) AcceptStackerCard' event
from curacc where currency_type = 401 and currency_val = 0
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE,0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
 0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID ,'   ' setclr, 0 alarm,
'(16) Curr Accepted ' ||
decode( FLOOR(0.01*currency_type), 2, 'Coin', 3, 'Bill', 4, 'Stacker', 'Other') ||
to_char(0.01 * currency_vaL, '999.99') event
from curacc
union
select  DET_SEQ_NUM ,FAREBOX_GLID ,CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
 0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , '   ' setclr, 0 alarm, '(17) Esc Key' event
from escapek;